IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'spShippersInsert')
	BEGIN
		DROP  PROCEDURE  spShippersInsert
	END
GO
-- =============================================
-- Author:		<NamTP>
-- Create date: <Apr 24, 2012>
-- Description:	<Get Company List Infomation>
-- TEST: EXEC spOrdersInsspShippersInsertert 17,2,''
-- =============================================
CREATE PROCEDURE spShippersInsert
	@CompanyName NVARCHAR(40),
	@Phone NVARCHAR(24)
AS
BEGIN
	INSERT INTO Shippers (CompanyName,Phone)
	VALUES (@CompanyName, @Phone)
	DECLARE @ShipperId INT
	SET @ShipperId = SCOPE_IDENTITY()
	SELECT @ShipperId
END
GO
